{include file="admin@public/header"/}

<link rel="stylesheet" href="/public/static/admin/css/report.css" />
<link rel="stylesheet" href="/public/static/admin/easyui/layui-v2.6.8/css/layui.css">
<!-- <link rel="stylesheet" type="text/css" href="/public/static/admin/easyui/jeasyui/themes/icon.css"> -->
<style>
	.ui-icon-ellipsis {
		right: 5px;
	}

	#filter-menu .con {
		width: 355px;
	}

	#filter-menu label.tit {
		width: 80px;
	}

	/*.ui-jqgrid tr.jqgrow td {
	white-space: normal !important;
	}
	*/
	.no-query {
		background: url("/public/static/admin/css/img/no_query.png") no-repeat scroll 100px 60px #fff;
		background-position: center;
		border: 1px solid #ddd;
		border-top: none;
		height: 402px;
		margin-right: 0;
	}

	.box-flex {
		overflow: hidden;
		zoom: 1;
	}

	.box-flex .flex {
		float: left;
		width: 33.3%;
	}

	.grid-title {
		font-size: 24px;
		text-align: center;
		clear: none;
	}

	.ui-print .grid-wrap {
		padding: 10px 0 0 30px;
	}

	#conditions-trigger {
		background: url(/public/static/admin/css/img/bg.png) no-repeat;
		border: 0px;
		width: 74px;
		box-shadow: 0px 0px;
	}

	#filter-menu .conditions-trigger>b {
		position: absolute;
		right: 0;
		top: 50%;
		margin-top: -8px;
		width: 16px;
		height: 16px;
		background: url(/public/static/admin/css/img/down.png) 2px 5px no-repeat;
	}

	#filter-menu .conditions-trigger>b.act {
		background: url(/public/static/admin/css/img/up.png) 2px 5px no-repeat;
	}

	#filter-menu .btns {
		position: absolute;
		top: 7px;
		right: 0px;
	}

	.layui-form-checkbox[lay-skin=primary] i {
		padding: 0;
	}

	.layui-form-checked[lay-skin=primary] i {
		border-color: #5dc5e7;
		background-color: #5dc5e7;
		color: #fff;
		padding: 0;
	}

	.layui-form-checkbox[lay-skin=primary]:hover i {
		border-color: #5dc5e7;
	}

	.layui-form-checkbox span {
		font-size: 12px;
	}

	.layui-form-checkbox[lay-skin=primary] {
		padding-left: 22px;
	}
</style>

<div class="wrapper">
	<!-- header -->
	<div class="mod-search cf">
		<div class="l  layui-form" id="filter-menu">
			<ul class="ul-inline fix" id="filterItems" style="height: 44px;font-size: 12px;">
				<li id="date" style="display: list-item;"><label>单据日期:</label>
					<input type="date" id="startdate" class="ui-input " value="2021-08-09" style="width: 125px;">
					<span class="todate"> 至 </span>
					<input type="date" id="enddate" class="ui-input " value="2021-08-09" style="width: 125px;">
				</li>
				<!-- 选择客户类别 -->
				{include file="admin@select/customer_category"/}

				<!-- 选择客户 -->
				{include file="admin@select/customer"/}

				<!-- 选择销售人员 -->
				{include file="admin@select/staff"/}

				<li id="realUser" style="display: list-item;">
					<label>制单人:</label>
					<span class="mod-choose-input" id="customer">
						<input type="text" class="ui-input" id="realUserAuto" autocomplete="off">
						<span class="ui-icon-ellipsis"></span>
					</span>
				</li>
				<li id="billNum" style="display: list-item;">
					<label>销售单号:</label>
					<input type="text" value="" style="width:115px;font-size: 12px;" class="ui-input ui-input-ph"
						name="matchCon" id="matchCon" placeholder="请输入单号查询">
				</li>
				<li id="remarks" style="display: list-item;">
					<label>整单备注:</label>
					<input type="text" value="" style="width:150px;font-size: 12px;" class="ui-input ui-input-ph"
						name="remarkCon" id="remarkCon" placeholder="请输入备注查询">
				</li>
				<li id="status-wrap" style="display: list-item;padding-top: 14px;height: 44px;box-sizing: border-box;">
					<input type="checkbox" name="status" id="" lay-skin="primary" title="销货" value="0">
					<input type="checkbox" name="status" id="" lay-skin="primary" title="退货" value="1">
				</li>
				<li class="chk-list" id="chk-blank"
					style="display: list-item;padding-top: 14px;height: 44px;box-sizing: border-box;">
					<input type="checkbox" name="showBlank" id="profit" lay-skin="primary" title="是否显示商品明细" value="1">
				</li>


				<div class="btns" style="top:0;"><a class="ui-btn mrb ui-btn-search" id="filter-submit">查询</a></div>
				<!-- <span class="url-box" id="openUrl"><a href="https://club.kingdee.com/club/newclub/school/course?product_id=7&amp;cid=1548#pid=5713" target="_blank" class="video-icon" style="margin-right: 5px;"></a>功能简介</span> -->
			</ul>
			<a href="#" id="conditions-trigger" class="ui-btn conditions-trigger" tabindex="-1">&nbsp;更多条件<b></b></a>
		</div>
	</div>

	<!-- 选择客户类别下拉 -->
	{include file="admin@popup/customer_category"/}

	<!-- no data -->
	<div class="no-query"></div>
	<!-- grid begin -->
	<div class="ui-print" id="ui-print" style="visibility: hidden;">
		<!-- 列配置 -->
		<div class="cf box-flex">
			<div class="flex">
				<span id="config" class="ui-config"><a href="#" class="ui-icon-config-new"></a>列设置</span>
			</div>

			<div class="grid-title flex">销售利润表</div>
			<div class="fr">
				<a href="#" class="ui-btn ui-btn-export btn-sm mrb fl" id="btn-export">导出</a>
				<a href="javascript:void(0)" class="ui-btn ui-btn-print btn-sm fl" id="btn-print"
					onclick="preview(1)">打印</a>
			</div>
		</div>

		<div class="grid-wrap" id="grid-wrap" style="padding-bottom: 30px;padding-right: 30px;">
			<!--startprint-->
			<!-- <div class="grid-title">销售利润表</div> -->
			<div class="grid-subtitle"></div>
			<table id="grid"></table>
			<!--endprint-->
			<div id="page"></div>
		</div>
	</div>
	<!-- grid end -->

	<!--  以隐藏的方式获取商品的样式 ，作用是赋值 -->
	<div style="display:none;">
		<input type="text" id="supplierid" value="" autocomplete="off" readonly="">

		<input type="text" id="goodsid" value="" autocomplete="off" readonly="">
		<input type="text" id="goodsname" value="" autocomplete="off" readonly="">
		<input type="text" id="goodstype" value="" autocomplete="off" readonly="">
		<input type="text" id="goodsmark" value="" autocomplete="off" readonly="">
		<input type="text" id="goodsdw" value="" autocomplete="off" readonly="">
	</div>
</div>

<script type="text/javascript" src="/public/static/admin/easyui/jeasyui/jquery.easyui.min.js"></script>
<script type="text/javascript">
	function preview(oper) {
		if (oper < 10) {
			$("#grid-wrap").jqprint();
		} else {
			window.print();
		}
	}


</script>


<script type="text/javascript">

	$(document).ready(function () {
		let isGoodsDetails = 0;
		// 点击查询按钮
		$("#filter-submit").click(function () {
			$("#ui-print").css({ "visibility": "visible" });  //显示表格数据
			$(".no-query").hide();  //隐藏提示

			// 设置表格高度
			$("#grid").setGridHeight($(window).height() - 230 - $("#filter-menu").height() + "px");

			// 判断是否显示商品明细
			if ($("#profit").get(0).checked) {
				$("#grid").setGridParam().showCol("goods_category");
				$("#grid").setGridParam().showCol("goods_sn");
				$("#grid").setGridParam().showCol("goods_name");
				$("#grid").setGridParam().showCol("goods_model");
				$("#grid").setGridParam().showCol("goods_dw");
				$("#grid").setGridParam().showCol("goods_dj");
				$("#grid").setGridParam().showCol("goods_hsdj");
				$("#grid").setGridParam().showCol("goods_dwcb");
				isGoodsDetails = 1;
			} else {
				$("#grid").setGridParam().hideCol("goods_category");
				$("#grid").setGridParam().hideCol("goods_sn");
				$("#grid").setGridParam().hideCol("goods_name");
				$("#grid").setGridParam().hideCol("goods_model");
				$("#grid").setGridParam().hideCol("goods_dw");
				$("#grid").setGridParam().hideCol("goods_dj");
				$("#grid").setGridParam().hideCol("goods_hsdj");
				$("#grid").setGridParam().hideCol("goods_dwcb");
				isGoodsDetails = 0;
			}

			var startdate = $('#startdate').val();
			var enddate = $('#enddate').val();
			$("div.grid-subtitle").text("日期: " + startdate + " 至 " + enddate);


			//此处可以添加对查询数据的合法验证 
			$("#grid").jqGrid('setGridParam', {
				datatype: 'json',
				postData: { 'ajax': '100', isGoodsDetails: isGoodsDetails }, //发送数据 
				page: 1
			}).trigger("reloadGrid"); //重新载入 
		});

		//alert("1111");
		$("#grid").jqGrid({
			url: '/sales/saleprofitdetail/index.html',
			datatype: "json",//数据来源，本地数据（local，json,jsonp,xml等）
			height: '90%',//高度，表格高度。可为数值、百分比或'auto'
			//width: Public.setGrid().w,
			//height: Public.setGrid().h,
			colNames: ["", "单据日期", "客户", "销售人员", "制单人", "单据编号", "业务类别", "商品类别", "商品编号", "商品名称", "规格型号", "单位", "数量", "单价", "含税单价", "折扣额", "销售收入", "税额", "价税合计", "单位成本", "销售成本", "销售毛利<br/>(销售收入-销售成本)", "毛利率%<br/>(销售毛利/销售收入)", "优惠金额", "销售费用", "销售净利润<br/>(销售毛利-优惠金额-销售费用)", "净利率%<br/>(销售净利润/销售收入)", "优惠后金额", "客户承担费用", "应收金额", "已收金额", "整单备注"],
			colModel: [
				{ name: '', index: 'id', width: 80, label: "id", hidden: true, frozen: true },
				{ name: 'dj_time', index: 'name asc', width: 150, label: "单据日期", align: "center", frozen: true },
				{ name: 'customer', index: 'name asc', width: 150, label: "客户", align: "center", frozen: true },
				{ name: 'saler', index: 'name asc', width: 100, label: "销售人员", align: "center", frozen: true },
				{ name: 'add_user', index: 'name asc', width: 100, label: "制单人", align: "center", frozen: true },
				{ name: 'sn', index: 'name asc', width: 110, label: "单据编号", align: "center", frozen: true },
				{ name: 'o_type', index: 'name asc', width: 80, label: "业务类别", align: "center" },
				{ name: 'goods_category', index: 'name asc', width: 120, label: "商品类别", align: "center" },
				{ name: 'goods_sn', index: 'name asc', width: 100, label: "商品编号", align: "center" },
				{ name: 'goods_name', index: 'name asc', width: 100, label: "商品名称", align: "center" },
				{ name: 'goods_model', index: 'name asc', width: 70, label: "规格型号", align: "center" },
				{ name: 'goods_dw', index: 'name asc', width: 70, label: "单位", align: "center" },
				{ name: 'number', index: 'name asc', width: 70, label: "数量", align:'right' },
				{ name: 'goods_dj', index: 'name asc', width: 70, label: "单价", align:'right' },
				{ name: 'goods_hsdj', index: 'name asc', width: 70, label: "含税单价" , align:'right'},
				{ name: 'zk_e', index: 'name asc', width: 70, label: "折扣额" },
				{ name: 'jine', index: 'name asc', width: 70, label: "销售收入" },
				{ name: 'tax_e', index: 'name asc', width: 70, label: "税额" },
				{ name: 'total_price', index: 'name asc', width: 70, label: "价税合计", align:'right' },
				{ name: 'goods_dwcb', index: 'name asc', width: 70, label: "单位成本", align:'right' },
				{ name: 'xscb', index: 'name asc', width: 70, label: "销售成本" , align:'right'},
				{ name: 'xsml', index: 'name asc', width: 150, label: "销售毛利", align:'right' },
				{ name: 'mlv', index: 'name asc', width: 150, label: "毛利率%", align:'center' },
				{ name: 'yh_e', index: 'name asc', width: 70, label: "优惠金额", align:'right' },
				{ name: 'saler_user_price', index: 'name asc', width: 70, label: "销售费用" },
				{ name: 'xsjlr', index: 'name asc', width: 180, label: "销售净利润", align:'right' },
				{ name: 'jll', index: 'name asc', width: 180, label: "净利率%", align:'center' },
				{ name: 'yh_price', index: 'name asc', width: 70, label: "优惠后金额" , align:'right'},
				{ name: 'user_cd_price', index: 'name asc', width: 70, label: "客户承担费用" , align:'right'},
				{ name: 'ys', index: 'name asc', width: 70, label: "应收金额", align:'right' },
				{ name: 'ss', index: 'name asc', width: 70, label: "已收款金额", align:'right' },
				{ name: 'mark', index: 'name asc', width: 150, label: "整单备注" },
			],
			rowNum: 10,
			rowList: [10, 20, 30],
			sortname: 'id',
			sortorder: "desc",
			pagerpos: "left",//分页位置

			pgbuttons: true,//翻页按钮
			pagination: true,
			altRows: false,
			gridview: !0,
			shrinkToFit: !1,
			cellLayout: 8,
			autowidth: !0,
			pager: "#page",
			viewrecords: !0,
			cmTemplate: {
				sortable: !1,
				title: !1
			},
			// 合计
			footerrow: true,
			gridComplete: function () {
				var numbers =parseFloat($("#grid").getCol('number', false, 'sum')).toFixed(2);
				var jines =parseFloat($("#grid").getCol('jine', false, 'sum')).toFixed(2);
				var tax_es =parseFloat($("#grid").getCol('tax_e', false, 'sum')).toFixed(2);
				var total_prices =parseFloat($("#grid").getCol('total_price', false, 'sum')).toFixed(2);
				var xscbs =parseFloat($("#grid").getCol('xscb', false, 'sum')).toFixed(2);
				var xsmls =parseFloat($("#grid").getCol('xsml', false, 'sum')).toFixed(2);
				var mlvs =parseFloat($("#grid").getCol('mlv', false, 'sum')).toFixed(2);
				var yh_es =parseFloat($("#grid").getCol('yh_e', false, 'sum')).toFixed(2);
				var xsjlrs =parseFloat($("#grid").getCol('xsjlr', false, 'sum')).toFixed(2);
				var jlls =parseFloat($("#grid").getCol('jll', false, 'sum')).toFixed(2);
				var yh_prices =parseFloat($("#grid").getCol('yh_price', false, 'sum')).toFixed(2);
				var yss =parseFloat($("#grid").getCol('ys', false, 'sum')).toFixed(2);
				var sss =parseFloat($("#grid").getCol('ss', false, 'sum')).toFixed(2);
				$("#grid").footerData('set', { "dj_time": '合计：', number: numbers, jine:jines ,tax_e:tax_es, total_price:total_prices, xscb:xscbs, xsml:xsmls, mlv:mlvs, yh_e:yh_es, xsjlr:xsjlrs, jll:jlls, yh_price:yh_prices, ys:yss, ss:sss});
			
				// 合并合计单元格
				var $footRow = $("#grid").closest(".ui-jqgrid-bdiv").next(".ui-jqgrid-sdiv").find(".footrow");
				$footRow.find('>td[aria-describedby="grid_dj_time"]').css("border-right-color", "transparent");

			},
			loadError: function (t, e, i) {
				parent.Public.tips({
					type: 1,
					content: "操作失败了哦，请检查您的网络链接！"
				})
			}

		});
		$("#grid").jqGrid('setFrozenColumns');//设置冻结列生效


		var headH = 0;  //顶部搜索是否展开（1：展开，0：未展开）
		$("#conditions-trigger").click(function () {
			if (headH == 0) {
				headH = 1;
				$("#filterItems").css({ "height": "auto" });
				$(this).html("&nbsp;收起条件<b class='act'></b>");
				// 设置表格高度
				$("#grid").setGridHeight($(window).height() - 230 - $("#filter-menu").height() + "px");
			} else {
				headH = 0;
				$("#filterItems").css({ "height": "44px" });
				// $("#filterItems").animate({height:'44px'});
				$(this).html("&nbsp;更多条件<b></b>");
				// 设置表格高度
				$("#grid").setGridHeight($(window).height() - 230 - $("#filter-menu").height() + "px");
			}
		});
		// 点击下拉框其他位置隐藏
		$(document).click(function () {
			$("#filterSelectBox").hide();
		});
		// 阻止冒泡
		$("#filter .ui-tree-wrap,#goodsfilter .ui-tree-wrap").click(function (event) {
			event.stopPropagation();
		});

		// 获取当前日期
		var myDate = new Date;
		var year = myDate.getFullYear(); //获取当前年
		var mon = myDate.getMonth() + 1; //获取当前月
		var date = myDate.getDate(); //获取当前日
		console.log(year + '-' + mon + '-' + date)
		if (mon < 10) {
			mon = "0" + mon;
		}
		if (date < 10) {
			date = "0" + date;
		}
		$("#startdate").val(year + '-' + mon + '-01');
		$("#enddate").val(year + '-' + mon + '-' + date);
	});

	function cLink(cellvalue, options, rowObject) {
		// console.log(rowObject.status);
		if (rowObject.status == 0) {
			return '<span class="set-status open" data-delete="false" onclick="switchs(this,' + rowObject.id + ')"><span class="ui-icon-circle"></span></span>';
		} else {
			return '<span class="set-status close" data-delete="false" onclick="switchs(this,' + rowObject.id + ')"><span class="ui-icon-circle"></span></span>';
		}

	}

	function actions(cellvalue, options, rowObject) {
		return '<div class="operating"><span class="ui-icon ui-icon-pencil" onclick="lopen(\'edit.html?id=' + rowObject.id + '\',\'编辑\',\'400px\',\'300px\')">修改</span> <span class="ui-icon ui-icon-trash" onclick="del(' + rowObject.id + ')">删除</span></div>';
	}

	function switchs(obj, id) {
		if ($(obj).hasClass("open")) {
			$(obj).removeClass("open");
			$(obj).addClass("close");
			status = 1;
		} else {
			$(obj).removeClass("close");
			$(obj).addClass("open");
			status = 0;
		}

		$.ajax({
			type: 'POST',
			url: "save.html",
			data: { id: id, status: status },
			dataType: "json",
			async: false,
			error: function (request) {
				layer.msg("发送请求失败！");
			},
			success: function (data) {
				if (data.status == 1) {
					layer.msg(data.msg);
				} else {
					layer.msg(data.msg);
				}

			}
		});
	}

	// 顶部搜索下拉选择窗口(供应商类别)
	function chooseFilter() {
		var top = $("#filter .ui-tree-wrap").offset().top;
		var left = $("#filter .ui-tree-wrap").offset().left;
		var width = $("#filter .ui-tree-wrap").width();
		$("#filterSelectBox").toggle();
		$("#filterSelectBox").css({ "top": (top + 30) + "px", "left": (left) + "px", "minWidth": width + "px" });
	}
	// 顶部搜索下拉选择窗口(供应商类别)
	function chooseGoodsfilter() {
		var top = $("#goodsfilter .ui-tree-wrap").offset().top;
		var left = $("#goodsfilter .ui-tree-wrap").offset().left;
		var width = $("#goodsfilter .ui-tree-wrap").width();
		$("#filterSelectBox").toggle();
		$("#filterSelectBox").css({ "top": (top + 30) + "px", "left": (left) + "px", "minWidth": width + "px" });
	}

</script>

{include file="admin@public/footer"/}